Lauren Kleitz ✭✭✭✭

Overview

Overview

Roles	Member
Badges	19

About Me

About Me

Area of Expertise	Analytics & Formulas; Automation; Reporting
How I Use Smartsheet	To optimize data collection, reporting, and project management at institutions of higher education.
Linkedin	https://www.linkedin.com/in/laurenkleitz/

Analytics

18

Posts

210

Visits

1.8k

Points

Sep 17, 2020

Join Date

Feb 5, 2025

Last Active

Reactions

• Insightful 2

  2
• Vote Up 6

  6
• Awesome 2

  2

• Activity
• Discussions
• Comments18

• Re: Pull the first non-blank value from a range of cells in a row

  Lauren Kleitz

  12/14/20
  Hey Sarah! If I am understanding correctly, I think you could use the Join function for this! Your function (in the master column) would look something like: =Join([Column 1]@row:[Column 4]@row) No m…
  1 ·

• Re: Auto-assign # based on parent or child (sub-item)

  Lauren Kleitz

  12/11/20
  I don't see your attachment but if you are looking for any parent row to be a 0, any sub task to be a 1, any sub-subtask to be a 2, and so on, this formula should work: =Count(Ancestors()) Let me kno…
  1 ·